package com.woniuxy.threeprojcet.end_water_project_admin.dao;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.woniuxy.threeprojcet.end_water_project_admin.domain.Repair;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.woniuxy.threeprojcet.end_water_project_admin.domain.form.RePairForm;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 维修表 Mapper 接口
 * </p>
 *
 * @author Lucas
 * @since 2021-08-26
 */
public interface RepairMapper extends BaseMapper<Repair> {

    @Select("select r.* , u.address from wn_repair r JOIN wn_user u where r.user_id =u.user_id ORDER BY r.repair_time DESC")
    IPage<RePairForm> getRepair(IPage page);

}
